package com.whw.fy.mapper;
import java.util.Date;

import com.whw.fy.entity.Comment;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface CommentMapper {
    int deleteByPrimaryKey(Integer commId);

    int insert(Comment record);

    int insertSelective(Comment record);

    Comment selectByPrimaryKey(Integer commId);

    int updateByPrimaryKeySelective(Comment record);

    int updateByPrimaryKey(Comment record);

    int batchInsert(@Param("list") List<Comment> list);

     List<Comment> selectAll();
    /**
     * select all
     * @return List
     */

    List<Comment> selectAllByCommByReviewersAndCommType(@Param("commByReviewers")Integer commByReviewers,@Param("commType")String commType);


    List<Comment> selectAllByCommByReviewers(@Param("commByReviewers")Integer commByReviewers);


    List<Comment> selectByAll(Comment comment);

    List<Comment> selectAllByCommClassIdAndCommByReviewersAndCommClassSkcdAndCommType(@Param("commClassId")Integer commClassId,@Param("commByReviewers")Integer commByReviewers,@Param("commClassSkcd")Integer commClassSkcd,@Param("commType")String commType);

    List<Comment> selectByCommClassIdAndCommClassSkcd(@Param("commClassId")Integer commClassId,@Param("commClassSkcd")Integer commClassSkcd);


}
